package cn.springboot.erp.entity;

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.annotation.ExcelTarget;
import com.baomidou.mybatisplus.annotation.*;

import java.io.Serializable;
import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

/**
 * 
 * @TableName suppliers
 */
@TableName(value ="suppliers")
@Data
@ExcelTarget("suppliers")
public class Suppliers implements Serializable {
    /**
     * 供应商ID
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    /**
     * 供应商名称
     */
    @Excel(name = "供应商名称",orderNum = "1")
    @TableField(value = "name")
    private String name;

    /**
     * 联系人姓名
     */
    @Excel(name = "联系人",orderNum = "2")
    @TableField(value = "contact_name")
    private String contactName;

    /**
     * 手机号码
     */
    @Excel(name = "手机号",orderNum = "3")
    @TableField(value = "phone")
    private String phone;

    /**
     * 邮箱
     */
    @Excel(name = "邮箱",orderNum = "4")
    @TableField(value = "email")
    private String email;

    /**
     * 地址
     */
    @Excel(name = "地址",orderNum = "5")
    @TableField(value = "address")
    private String address;

    /**
     * 供应商描述
     */
    @Excel(name = "描述",orderNum = "6")
    @TableField(value = "description")
    private String description;

    /**
     * 创建时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    @TableField(value = "create_time",fill = FieldFill.INSERT)
    private Date createTime;

    /**
     * 修改时间
     */
    @TableField(value = "update_time",fill = FieldFill.INSERT_UPDATE)
    private Date updateTime;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;
}